package com.lv.db.entity;

import java.io.Serializable;

/**
 * Created by Xulin on 2017/5/18
 * email xulin67@163.com.
 */

public class LinkMan implements Serializable {

    private Integer fid;
    private String fphone = "";
    private String fname = "";
    private String favatar = "";
    private String fstate = "0"; //0 初始化
    private String fcontactid = "";
    private String fspelledall;//全拼
    private String fspellsort;//排序首字母

    public Integer getFid() {
        return fid;
    }

    public void setFid(Integer fid) {
        this.fid = fid;
    }

    public String getFcontactid() {
        return fcontactid;
    }

    public void setFcontactid(String fcontactid) {
        this.fcontactid = fcontactid;
    }

    public String getFphone() {
        return fphone;
    }

    public void setFphone(String fphone) {
        this.fphone = fphone;
    }

    public String getFname() {
        return fname;
    }

    public void setFname(String fname) {
        this.fname = fname;
    }

    public String getFavatar() {
        return favatar;
    }

    public void setFavatar(String favatar) {
        this.favatar = favatar;
    }

    public String getFstate() {
        return fstate;
    }

    public void setFstate(String fstate) {
        this.fstate = fstate;
    }

    public String getFspelledall() {
        return fspelledall;
    }

    public void setFspelledall(String fspelledall) {
        this.fspelledall = fspelledall;
    }

    public String getFspellsort() {
        return fspellsort;
    }

    public void setFspellsort(String fspellsort) {
        this.fspellsort = fspellsort;
    }

    public LinkMan() {
    }

    public String tableName() {
        return "LINK_MAN_TABLE";
    }

    public String tableDef() {
        String tableDef = "CREATE TABLE " + tableName() + " "
                + "(FID INTEGER primary Key autoincrement"
                + ",FNAME varchar(50)"
                + ",FPHONE varchar(50)"
                + ",FCONTACTID varchar(50)"
                + ",FAVATAR varchar(500)"
                + ",FSTATE varchar(15)"
                + ")";
        return tableDef;
    }

    public String _fid() {
        return "FID";
    }

    public String _fname() {
        return "FNAME";
    }

    public String _fphone() {
        return "FPHONE";
    }

    public String _fcontactid() {
        return "FCONTACTID";
    }

    public String _favatar() {
        return "FAVATAR";
    }

    public String _fstate() {
        return "FSTATE";
    }

    public String _fspellsort(){return "FSPELLSORT";}

    public String _fspelledall(){return "FSPELLEDALL";}

}
